Guided web-application generation

ABSTRACT

Techniques are described herein for generating and managing Web applications. Embodiments include receiving organized data and analyzing the organized data to determine one or more data types contained in the organized data. Based on the one or more data types, suggested widgets are determined, including determining whether a particular data type can be split into two or more data types and suggesting widgets for each split data type. The suggested widgets are presented to a user, and in response to user input accepting the suggested widgets, a Web application comprising the suggested widgets is generated.

BACKGROUND

The approaches described in this section are approaches that could bepursued, but not necessarily approaches that have been previouslyconceived or pursued. Therefore, unless otherwise indicated, it shouldnot be assumed that any of the approaches described in this sectionqualify as prior art merely by virtue of their inclusion in thissection.

Users in small and medium business (SMBs) environments need to track andorganize data for a variety of business tasks, such as purchase orders,trial requests, daily transactional data, and etc. SMB users may usespreadsheet software, simple database applications, or word processingsoftware to store data. However, the data is typically stored as files,and multiple users may not access or modify a file at the same time.Users may generate multiple copies of a file in order to share the filewith others or track changes to the data, or store multiple filescorresponding to different business tasks. It is difficult for users toconsolidate data between versions of a file, determine which file is themost current, or otherwise share and organize files.

A large database system allows many users or client applications toconnect to the database at the same time. However, large databasesystems may be costly or impractical for a SMB to implement. A largedatabase system incurs setup and administration costs that may exceedthe usefulness of such a system to a SMB. In addition, a databaseapplication may be specifically programmed based on particular usecases. A new application may need to be developed when new, uniquetransactions that do not correspond to existing use cases need to bestored.

Thus, it is desirable and beneficial to store and manage database datain a low cost, flexible system that allows sharing between multipleusers.

SUMMARY

According to another embodiment, a system includes one or moreprocessors and a non-transitory computer-readable medium storinginstructions. When executed by the one or more processors, theinstructions cause receiving organized data. In response to receivingthe organized data, a plurality of data types contained in the organizeddata are determined. One or more suggested widgets for each data type ofthe plurality of data types are determined. Determining the one or moresuggested widgets comprises determining a particular data type can besplit into two or more data types and determining a suggested widget foreach data type from the two or more data types of the particular datatype. The plurality of data types and the determined one or moresuggested widget for each data type of the plurality of data types aredisplayed, including the suggested widget for each data type from thetwo or more data types for the particular data type. In response toreceiving user input accepting the one or more suggested widgets, a Webapplication comprising the one or more suggested widgets is generated.

BRIEF DESCRIPTION OF THE DRAWINGS

In the drawings:

FIG. 1 is a block diagram that depicts an arrangement for generating andmanaging Web apps.

FIG. 2 depicts an example Web app graphical user interface.

FIG. 3 depicts an example graphical user interface for manually creatinga Web app.

FIG. 4 is a flow diagram that depicts an approach for guided generationof a Web app based on received organized data.

FIG. 5 depicts example organized data for generating a Web app.

FIG. 6 depicts a preview screen that includes one or more suggestedwidgets.

FIG. 7 is a block diagram that depicts an example computer system uponwhich embodiments may be implemented.

DETAILED DESCRIPTION

In the following description, for the purposes of explanation, numerousspecific details are set forth in order to provide a thoroughunderstanding of the present invention. It will be apparent, however,that the present invention may be practiced without these specificdetails. In other instances, well-known structures and devices are shownin block diagram form in order to avoid unnecessarily obscuring thepresent invention.

I. OVERVIEW

II. SYSTEM ARCHITECTURE

III. WEB APP OVERVIEW

-   -   A. Manual Creation    -   B. Automatic Generation

IV. BENEFITS OF CERTAIN EMBODIMENTS

V. IMPLEMENTATION EXAMPLES

I. General Overview

An approach is provided for generating Web applications, also referredto herein as Web apps. A Web application allows users to enter or importdata, and stores the data in a structured manner. For example, Webapplication data may structured similar to that of a spreadsheet or adatabase table. The Web application may be shared, accessed, edited, andutilized by multiple users.

According to the approach, organized data is received at a system forgenerating a Web application. In response to receiving the organizeddata, a plurality of data types contained in the organized data aredetermined. For example, the organized data may include names, whichcorrespond to a string data type, and zip codes, which correspond to anumeric data type. One or more suggested widgets for each data type isdetermined. For example, a string data type may correspond to a text boxwidget, a numeric data type may correspond to a number widget, a datedata type may correspond to a calendar widget, and etc. Determining theone or more suggested widgets may include determining that a particulardata type may be split into two or more data types. For example, astring data type corresponding to an address may be split into a numericdata type corresponding to the street number portion of the address anda string data type corresponding to the street name portion of theaddress. As another example, a string data type corresponding to acustomer name may be split into a first string data type correspondingto a first name of the customer and a second string data typecorresponding to a last name of the customer. As a third example, anumeric data type corresponding to a phone number may be split intothree numeric data types corresponding to a country code, an area code,and a main phone number, respectively. A suggested widget may bedetermined for each split data type.

The one or more suggested widgets for each data type and thecorresponding data type are displayed to a user, including the suggestedwidget for each of the split data types. The system may allow a user tosplit a data type into two or more data types or merge two or more datatypes into a single data type, and suggest one or more modified widgetsin response to the split or merge. In addition, the system may allow auser to modify or remove a suggested widget.

Upon receiving user input accepting the current set of suggestedwidgets, a Web application comprising the current set of suggestedwidgets is generated. The contents of the organized data may beautomatically imported as data managed by the generated Web application.

II. System Architecture

In the example depicted in FIG. 1, application server 110 includes datainterface 112, user interface 114, Web app management application 116,and one or more Web apps 118. Application server 110 providesfunctionality for creating, managing, and accessing Web apps. As anexample, application server 110 may generate and serve one or more Webpages that provide a graphical user interface for creating, managing,and accessing the Web apps. Application server 110 may include variousother components that may vary depending upon a particularimplementation and application server 110 is not limited to a particularset of components or features. Application server 110 may includevarious hardware and software components that may vary depending upon aparticular implementation and application server 110 is not limited toany particular hardware and software components.

Data interface 112 is configured to receive data from client device 102and may do so using various communication protocols and from variousmedia. Example protocols include, without limitation, the File TransferProtocol (FTP), the Telnet Protocol, the Transmission Control Protocol(TCP), the TCP/Internet Protocol (TCP/IP), the Hypertext TransferProtocol (HTTP), the Simple Mail Transfer Protocol (SMTP), or any otherdata communications protocol. Data interface 112 may be configured toread data from an FTP folder, an email folder, a Web server, a remotemedia such as a memory stick, or any other media. Data interface 112 mayinclude corresponding elements to support these transport methods.

For example, data interface 112 may include, or interact with, an FTPserver that processes requests from an FTP client on client device 102.As another example, data interface 112 may include, or interact with, anemail client for retrieving emails from an email server. As yet anotherexample, data interface 112 may include, or interact with, a Web serverthat responds to requests from an http client on client device 102. Datainterface 112 is further configured to support the transmission of datafrom application server 110 to other devices and processes, for example,client device 102, other computing devices, other services such as Webapp management application 116 and Web app 118, and etc.

User interface 114 provides a mechanism for a user, such as anadministrator, to access application server 110, data stored on storage120, and/or Web applications managed by Web app management application116, as described in more detail hereinafter. User interface 114 may beimplemented as an API for application server 110. Alternatively, userinterface 114 may be implemented by other mechanisms. For example, userinterface 114 may be implemented as a Web server that serves Web pagesto provide a Web-based user interface for application server 110.

Web app management application 116 provides functionality for generatingand managing Web apps. Example functionality includes receivingorganized data, analyzing the organized data to suggest one or morewidgets, and generating a Web app comprising the one or more suggestedwidgets. Example functionality also includes receiving user inputspecifying one or more widgets and generating a Web app comprising thespecified widgets, and modifying or deleting a generated Web app basedon user input. Modifying a Web app may include adding, modifying, orremoving one or more widgets from the Web app. Modifying the Web app mayalso include modifying the users who have permission to access, modify,and/or view data for a Web app.

According to one embodiment, Web app management application 116 providesa graphical user interface to allow user access to the aforementionedfunctionality. The graphical user interface may be provided byapplication software on client device 102, application software onapplication server 110 or any combination of application software onclient device 102 and application server 110. As one example, thegraphical user interface may be implemented by one or more Web pagesgenerated on application server 110 and provided to client device 102.Web app management application 116 may be implemented in computerhardware, computer software, or any combination of computer hardware andsoftware. For example, Web app management 116 may be implemented as anapplication, e.g., a Web application, executing on application server110.

One or more Web apps 118 are generated by Web app management application116. The one or more Web apps may be data management applications thatmanage and store data. For example, an order information Web app maymanage data related to orders received by a company, such as ordernumbers, order items, quantities, and total cost. An items Web app maystore item data for products that a company sells. Web apps may alsostore links to data stored by other Web apps, or import data stored byother Web apps. For example, the order information Web app may includeitem information retrieved from the items Web app.

Each Web app comprises one or more widgets. The one or more Web apps 118process and manage data received from client device 102 as described inmore detail below. Data managed by the Web apps 118 may be stored instorage 120.

According to one embodiment, a Web app 118 provides a graphical userinterface to allow users to add, modify, delete, or view data. Thegraphical user interface may be provided by application software onclient device 102, application software on application server 110, orany combination of application software on client device 102 andapplication server 110. As one example, the graphical user interface maybe implemented by one or more Web pages generated on application server110 and provided to client device 102. Web app management application116 may be implemented in computer hardware, computer software, or anycombination of computer hardware and software.

Storage 120 may include any type of storage, such as volatile memoryand/or non-volatile memory, hard drives, etc.

Network 130 may include any number and type of wired or wirelessnetworks, such as local area networks (LANs), wide area networks (WANs),one or more internetworks such as the public the Internet, a cellularnetwork, a company network, or etc. Network 130 may also include one ormore computing devices, such as one or more server computers,load-balancing computers, cloud-based computers, data centers, storagedevices, and/or any other special-purpose computing devices. The variouselements depicted in FIG. 1 may also communicate with each other viadirect communications links.

In one embodiment, client computing device 102 is any computing device,such as a work station, personal computer, general purpose computer,laptop, hand-held computer, wearable computer, cellular or mobile phone,portable digital assistant (PDA), tablet computer, and the like.Although embodiments are depicted in the figures and described herein inthe context of a single client computing device, this is done forexplanation purposes only, and embodiments are applicable to any numberof client computing devices. Each client computing device 102 iscommunicatively connected to server computer 110 through network 130.

Client computing device 102 may include other elements, such as one ormore input devices, memory, processors, and the like, which are notdepicted in FIG. 1 for purposes of explanation. Client computing device102 may also include applications, software, and other executableinstructions to facilitate various aspects of embodiments describedherein. These applications, software, and other executable instructionsmay be installed by a user, owner, manufacturer, or other entity relatedto the client computing device.

In one embodiment, client computing device 102 includes a browser. Abrowser is a computer application that may request and process Web pagesfrom Web servers, such as application server 110, to generate graphicaluser interfaces that are presented to a user through one or moredevices, such as a display.

III. Web App Overview

A Web app is an application executing on a server, such as applicationserver 110, that is accessible from a client computing device via anetwork. In an embodiment, the one or more Web apps 118 are datamanagement applications such as a spreadsheet or a database app. Usersmay input or import data into the Web app. The Web app stores andmanages the received data. The Web app may also provide variousvisualizations of the stored data, such as tables, graphs, charts, andmay also filter or sort the data.

In an embodiment, data managed by a Web app is stored in an organizedformat. For the purpose of illustrating a clear example, embodiments aredescribed herein wherein the data comprises one or more data records,each data record including a set of data fields. However, in otherembodiments, the data may be organized in other ways that may varydepending upon a particular implementation.

In an embodiment, a Web app includes one or more widgets. A widget, asused herein, refers to any control element in a graphical user interfaceof a Web app. A widget may be, for example: a display widget, an inputwidget, a user interface widget, a data processing widget, a decisionwidget, a dialog widget, an event listener widget, and etc. A widget mayalso be a combination of a plurality of widget types or functionality.In an embodiment, users enter data for the Web app using the one or morewidgets. Each widget of the Web app may correspond to a data field for adata record stored by the Web app. For example, a customer recordstoring customer information may include a customer name field and acustomer address field. A first widget may correspond to the customername field, and a second widget may correspond to the customer addressfield. A user may enter a customer name and a customer address using thefirst and second widgets, respectively. In response, the Web appgenerates and stores a data record comprising the customer informationthat was entered.

In an embodiment, each widget of the Web app is a particular widgettype. Example widget types include numeric, single-line text, multi-linetext, rich text, check box, radio button list, date/calendar, time,dropdown list, email, and etc. The type of data that is entered usingthe widget may vary depending on the widget type. Referring to the aboveexample, a widget for entering a customer name may be a single-line textwidget type.

In an embodiment, the Web app includes a graphical user interface fordata entry comprising the one or more widgets of the Web app. Graphicaluser interface elements corresponding to the one or more widgets may bearranged in a particular layout within the data entry graphical userinterface.

Each widget may include one or more properties. The properties mayinclude a widget name corresponding to the field name of the associateddata field. Additional properties for a widget may vary depending on theparticular widget type. The properties may specify the format, type,and/or other properties of the data entered into the widget. Forexample, a numeric widget type may include properties such as numberformat, minimum value, maximum value, comma placement, and decimalplacement. As another example, a dropdown widget type may include a listof dropdown values. In an embodiment, the one or more properties for awidget each include a default value.

In an embodiment, the widget types include a calculation widget type. Awidget that is a calculation widget type includes a formula property,and calculates a data value based on the formula. The formula mayinclude pre-defined values and/or specify values received from otherwidgets.

As an example, a Web app may include a widget corresponding to itemprice and a widget corresponding to order quantity. A calculation widgetcorresponding to order price may include the formula: “item price *order quantity.” After data is entered for the item price widget and theorder quantity widget, the order price widget may automaticallycalculate a value based on the data entered for the item price widgetand the order quantity widget. In addition, the calculation widget mayautomatically update its value when the corresponding widget values aremodified (e.g., item price and/or order quantity).

In an embodiment, the widget types include a lookup widget type. Awidget that is a lookout widget type includes a source app propertyvalue and a key field property value. The source app property valueindicates which Web app to look up data from, and the key field propertyvalue indicates the field or column whose value should be checked. Thewidget receives a lookup value and searches the source app for datarecords whose key field value matches the lookup value. The widget mayalso include a field mapping property. The field mapping maps a fieldvalue in the source app to a particular widget in the Web app. Selectinga particular record from one or more search results populates theparticular widget with the value of the mapped field.

Referring to the above example, an order information Web app may includea lookup widget that searches the “customer name” field of a Web appstoring customer data. The “customer ID” field from the customer dataWeb app is mapped to a “customer ID” widget in the order information Webapp. When a user inputs a customer name into the lookup widget, a set ofone or more records whose customer name matches the lookup value aredisplayed. The user may select a particular record from the one or morematching records, and the customer ID of the particular record isentered as the value for the “customer ID” widget in the orders Web app.In an embodiment, updating the corresponding record also updates themapped value.

In an embodiment, the Web app provides functionality for sorting,filtering, and displaying the managed data. The Web app may display thedata in a graphical format, such as a table, graph, chart, or other datavisualization. Data managed by the Web app may also be exported into adata file, such as a comma-separated value (CSV) file or other fileformat for storing organized data.

FIG. 2 illustrates an example Web app graphical user interface 200. Thegraphical user interface 200 includes a data portion 202 that displaysdata stored by the Web app. Data portion 202 includes controls formodifying a single data record, modifying multiple data records at thesame time (batch modifications), or modifying a single field. Thecontrols may allow a user to modify the record in-line, within the dataportion 202 display.

The graphical user interface 200 also includes a views list 204 thatdisplays a list of stored views. A stored view may specify data filters,sorting, grouping, and other data display options. Selecting a storedview may update the data displayed in data portion 202.

The graphical user interface 200 also includes a graphs list 206 thatdisplays a list of stored graphs. A stored graph may specify a graphtype and one or more data fields to be graphed. The stored graph mayalso group, aggregate, filter, and/or sort one or more data fields.Selecting a stored graph may cause a graph to be generated based on thecurrent set of data stored by the Web app.

A. Manual Web App Creation

In an embodiment, the Web app management application provides agraphical user interface for manually creating a Web app. A user mayselect one or more widgets to include in the Web app. The user may alsoarrange the widgets in a desired order and/or layout. For example, auser may drag and drop widgets into place within a Web app creation GUI.The user may also specify the properties for each widget. FIG. 3illustrates an example Web app creation GUI. The Web app creation GUI300 includes a widget selection portion 302 and a layout portion 304.The widget selection portion 302 displays a set of available widgets. Inthe illustrated example, the widget selection portion 302 indicates thewidget type of each widget.

A user may drag the user interface element corresponding to a widgetfrom widget selection portion 302 into a layout portion 304. The layoutportion 304 displays one or more user interface elements correspondingto widgets selected by the user. The user interface elementcorresponding to the selected widget may be placed in layout portion 304where it has been dropped, or the user interface element may be snappedinto a grid or other layout locations. In some embodiments,previously-placed user interface elements within layout portion 304 maybe moved to accommodate the dropped widget. As the user interfaceelement is dragged over layout portion 304, the positions of other userinterface elements within layout portion 304 may be updated to indicatewhere they would be moved to if the selected user interface element isdropped at the current location.

Referring to FIG. 3, after the user interface element for a widget isplaced in layout portion 304, the user interface element includesbuttons for modifying the widget properties and for deleting the widget.Selecting the properties button may launch a dialog where users caninput property values for widget properties. For example, for a numericwidget type, the user may be able to specify minimum and maximum valuesand specify a number format.

As another example, for a calculation widget, a graphical user interfacemay be provided for inputting a formula for the calculation. Thegraphical user interface may provide a list of other widgets in the Webapp and a list of operations. The user may select from the lists todefine a calculation.

As a third example, for a lookup widget, a graphical user interface maybe provided for selecting a lookup source and for specifying a fieldmapping. The graphical user interface may display a list of other Webapps managed by the Web app management application 116. After a sourceWeb app is selected, a list of widgets of the source Web app may bedisplayed. A widget from the source Web app may be mapped to a widget inthe current Web app. For example, available Web apps may include acustomers Web app and an items Web app. If customers is selected, thewidgets customer name, customer ID, customer address, and customer phonenumber may be displayed as widgets that may be mapped. Selectingcustomer ID, a numeric widget type, may cause a list of numeric widgettypes in the current widget, which can be mapped to customer ID, to bedisplayed.

In an embodiment, a user may select one or more layout widgets. A layoutwidget may be, for example, a label, divider, blank space, or othergraphical user interface component that affects the look or layout ofthe Web app.

The user may then choose to save the Web app. A new Web app is generatedcomprising the one or more widgets in the specified layout. When a newrecord is being added for the Web app, a graphical user interfacecomprising user interface elements corresponding to the one or morewidgets is displayed in the specified layout for data entry.

B. Guided Generation

FIG. 4 illustrates example steps for guided generation of a Web appbased on organized data.

At step 402, organized data for generating a Web app is received. Theorganized data may be retrieved in response to a user invoking the Webapp management application 116, selecting an option to import data forgenerating a Web app, and selecting a file containing the organizeddata. For example, a user may select an icon in a graphical userinterface of Web app management application 116 to invoke guided Web appgeneration instructions. The user is then queried for one or more filesto be used for generating the Web app. The user may then select one ormore files, or specify a location, e.g., a path, of one or more files tobe used.

The organized data may be retrieved from any source, such as from clientcomputing device 102, storage 120, another server computer, or anotherservice or application. The file may be a structured data file such asCSV, XLS, XML, JSON, and etc. Additionally or alternatively, the filemay be a document depicting a form or other structured document, such asan image file, text document, or a PDF. FIG. 5 depicts example organizeddata that includes one or more data types. In the illustrated example,the organized data is a spreadsheet table 500 comprising a plurality ofrows and columns.

At step 404, one or more data types contained in the organized data aredetermined. Referring to FIG. 5, a data type for each column of table500 is determined. This may be accomplished using a wide variety oftechniques that may vary depending upon a particular implementation andthe type of data file received, and embodiments are not limited to anyparticular technique for determining data types. For example, for atable, data types may be determined from labels. The labels may be, forexample, for rows and columns in the table. As another example, for atable, the data contained in each row of a column may be analyzed todetermine a data type of the column. If the data in all rows of thecolumn are a particular data type, such as all numeric values, then thedata type for the column is the particular data type. In someembodiments, if a data type cannot be determined, then a default datatype may be selected, such as text (string) data type. As anotherexample, a CSV file may be parsed to determine one or more recordscomprising one or more fields. The contents of the fields may beanalyzed to determine the one or more data types.

In an embodiment, the file may be a document depicting a form or otherstructured document. The file may be analyzed to identify one or morefields depicted in the document. A data type is determined for eachfield of the one or more fields. A variety of techniques may be used toidentify the one or more fields. For example, the file may be an imageof a form. Text recognition and/or image analysis may be used toidentify one or more fields depicted in the form.

In an embodiment, determining the one or more data types includesdetermining if a data type may be split into two or more data types.Determining whether a data type may be split may be based on analyzingthe portions of the organized data corresponding to the data type.Various techniques may be used to determine whether a data type may besplit into two or more data types.

In an embodiment, determining whether a data type may be split includesdetermining whether the corresponding data includes two or moresub-data-types. For example, the data type of an address field may be astring. The Web app management application 116 may analyze the data todetermine that the field comprises both numbers (the street number of anaddress) and letters (the street name). The string data type may besplit into a numeric data type and a string data type.

In an embodiment, determining whether a data type may be split includesdetermining whether the corresponding data includes one or moredelimiters, such as carriage return, line breaks, spaces, commas,semicolons, and etc. For example, the data type of a customer name fieldmay be a string. The Web app management application 116 may analyze thedata to determine that the customer names comprise a first string (firstname) and a second string (last name), separated by a space character.The string data type may be split into two string data types.

In an embodiment, in response to determining that a data type can besplit into two or more data types, the two or more data types arepresented to the user in a graphical user interface. The user may selectparticular data types of the two or more data types. For example, thegraphical user interface may indicate that a name string may be splitinto three strings: first name, middle name, and last name. A user maychoose to split the name string into only two strings: first name plusmiddle name, and last name. Based on the selection, the data type issplit into the selected data types.

Additionally or alternatively, suggested split data types are presentedto the user in a graphical user interface. The user may modify or acceptthe data types for the two or more data types. For example, thegraphical user interface may present a drop-down box for each suggestedsplit data type indicating the suggested data type and a list ofalternate data types. The user may modify a data type by selecting analternate data type from the drop-down box.

As an example, Web app management application 116 may determine that astring data type can be split into a number data type and a string datatype. A graphical user interface may display a first drop-down box witha number data type selected, and a second drop-down box with a stringdata type selected. The user may indicate that the string should besplit into two strings rather than a number and a string

Additionally or alternatively, data types that can be split into two ormore data types are presented to the user in a graphical user interface.The user may select which data types should be split into two or moredata types. In response to receiving the selection, the selected datatypes are split into two or more data types. For example, the organizeddata may include a string data type corresponding to an address, astring data type corresponding to a name, and a string data typecorresponding to a set of geographic coordinates. Web app managementapplication 116 may determine that the three string data types can eachbe split into two or more data types. The graphical user interface maydisplay a selectable list comprising the address, the name, and thegeographic coordinates, and/or the three string data types. The user mayselect each string data type that should be split into two or more datatypes. For example, the user may indicate that string data typescorresponding to the address and the name should be split, but that thestring data type corresponding to the set of geographic coordinatesshould not be split. In response, the selected string data types may besplit as described above.

At step 406, the Web app management application 116 determines, for eachdata type of the one or more data types, one or more suggested widgets.Each suggested widget is a widget type corresponding to the data type.For example, a numeric widget may be suggested for a numeric data type,a date widget may be selected for a date data type, and etc. In anembodiment, a plurality of widgets are potential suggested widgets for adata type. A particular widget of the plurality may be selected based onthe portion of the organized data corresponding to the data type. Forexample, widget types of potential suggested widgets for a string/textdata type may include single-line text, multi-line text, rich text, ordropdown box. If data corresponding to the data type includes multiplelines of text or text that is over a certain number of characters, thena multi-line text widget may be suggested. If the data includes alimited number of options (e.g., multiple rows have the same value for acolumn), a dropdown widget may be suggested.

In an embodiment, if a data type was split into two or more data types,a suggested widget is determined for each data type of the two or moresplit data types.

At step 408, the suggested widgets are displayed to the user in agraphical user interface. In an embodiment, the suggested widgets aredisplayed along with a preview of the data corresponding to thesuggested widget. For example, one or more portions of the organizeddata that correspond to a suggested widget may be displayed with thesuggested widget. FIG. 6 depicts an example display that may bepresented to a user. In the illustrated example, a plurality ofsuggested widgets are presented in a header row. The widget type foreach suggested widget is displayed. The subsequent rows display rows,where each column of a row includes data corresponding to the suggestedwidget shown above. Each row may correspond to a data record of the Webapp, if generated, and each column of the row may correspond to a datafield of the data record.

In an embodiment, the graphical user interface allows the user tore-order the suggested widgets, modify a suggested widget, split asuggested widget into two or more suggested widgets, or merge two ormore suggested widgets into a single widget. Modifying a suggestedwidget may include changing the widget type or removing the suggestedwidget.

As an example, in response to a user request to merge two or morewidgets, a suggested widget for the merged widget may be presented. Thewidget type of the suggested widget may be based on the widget types ofthe two or more widgets. For example, if a date widget and a time widgetare merged, the suggested widget may be a date-time widget. Additionallyor alternately, the widget type of the suggested widget may be a defaultwidget type, such as single-line text. For example, if the two or morewidgets correspond to incompatible widget types then the default widgettype may be selected. Widget types may be incompatible if they do notcorrespond to the same data types. For example, two widgets may beincompatible if the first corresponds to a date data type and the secondcorresponds to a string data type. In addition, the preview of thecorresponding data may be modified to indicate the merge.

For example, a single-line text widget may correspond to a city and adrop-down list widget may correspond to a state. The single-line textwidget may be displayed with one or more cities contained in theorganized data, and the drop-down list widget may be displayed with oneor more states contained in the organized data. A user may select thesingle-line text widget and the drop-down list widget, and select abutton or other user interface element indicating that the two widgetsshould be merged. In response, the single-line text widget and thedrop-down list widget may be removed and replaced with a single-linetext widget corresponding to a combination of city and state. The eachof the one or more cities and the one or more states may be paired, andthe one or more pairs are displayed in association with the mergedsingle-line text widget.

In an embodiment, a plurality of possible widget types are determinedand the user may select a widget type of the plurality. For example, ifa drop-down list widget and a radio button list widget are merged, themerged widget type may be any widget type that allows selecting anoption from a list, such as a drop-down list, a radio button list, acombo box, and etc. A suggested may be presented to the user as part ofa selectable list, and the user may select an alternate widget type fromthe list of options.

In an embodiment, widgets of particular widget types are not able to bemerged. For example, calculation widgets and lookup widgets may not bemerged with other widgets. The user may not be able to select a widgetof these particular widget types to merge them with other widgets.

As another example, in response to a user request to split a particularwidget into two or more widgets, a set of suggested widgets may bedetermined based on the particular widget. In addition, the preview ofthe corresponding data may be modified to indicate the split. Forexample, a single-line text widget may correspond to customer addressesand be displayed with one or more customer addresses contained in heorganized data. In response to a user request to split the single-linetext widget, the widget may be split into a number widget correspondingto street numbers and a single-line text widget corresponding to streetnames. The preview may be updated such that the number widget isdisplayed with the street numbers of the one or more customer addressesand the single-line text widget is displayed with the street names ofthe one or more customer addresses.

In an embodiment, in response to receiving a request to split aparticular widget, the Web app management application 116 determinesthat the data type corresponding to the particular widget may be splitinto two or more data types. Determining that the particular data typemay be split into two or more data types may be based on the datacorresponding to the data type, as described above. A suggested widgetmay be determined for each of the two or more data types. In anembodiment, the graphical user interface may display an indication ofthe potential split. The user may modify each data type and/or thesuggested widget for each data type.

Additionally or alternatively, the user may specify the number ofwidgets into which to split the particular widgets and/or the type ofwidgets. The Web app management application may automatically split theparticular widget into the specified number of widgets. In anembodiment, if the corresponding data type cannot be automatically splitinto two or more data types as specified, a notification may be sent tothe user and the split may not be completed. Alternately, the user mayindicate how the data should be split, or the widget may be split butthe data may be associated with fewer than all of the split widgets. Asan example, one or more portions of the organized data corresponding tothe data type may be displayed in a graphical user interface. The usermay identify, using the graphical user interface, how the one or moreportions of the organized data should be split. For example, the usermay draw dividing lines, boxes, or other indicators around parts of thedisplayed data. The data type is split based on the user input. Asanother example, a particular widget corresponding to customer names maybe split into three widgets corresponding to first name, middle initial,and last name, respectively. One or more customer names may not includea middle initial. When the widget is split, not all customer names maybe split such that data is associated with the middle initial widget.

At step 410, in response to receiving user input accepting the suggestedwidgets, a Web app is generated comprising the set of suggested widgets.If the user modified, moved, split, or merged widgets, the Web appincludes the modifications to the set of suggested widgets.

At step 412, the organized data is automatically added to the new Webapp. If a data type was split into two or more data types, adding theorganized data includes splitting the corresponding portions of theorganized data. If two or more data types were merged into a single datatype, adding the organized data includes merging the correspondingportions of the organized data.

For example, the organized data may be divided into one or more records.Data for each record may be divided into one or more fields, where eachfield corresponds to a widget of the Web app. The organized data isstored as a plurality of data records, each data record comprising arespective one or more data fields.

IV. Benefits of Certain Embodiments

One of the problems with conventional spreadsheet files and spreadsheetsoftware is that each user that wishes to view or modify a spreadsheethas to have software compatible with the spreadsheet file. In addition,multiple users cannot concurrently open the file at the same time. In anembodiment, an approach is described for storing and managing data usingWeb apps. The approach allows storing spreadsheet data in any networkstorage system, including cloud systems hosted in a distributed networkof servers. The Web apps may be accessed by any user using any computingdevice with a Web browser. In addition, according to some embodiments,multiple users may connect to an application server and access the sameWeb app at the same time. Web apps may also be assigned user permissionssuch that some users may view, add, or modify data, while some users mayonly view the data but may not add data or modify the existing data. Asa result, the approach reduces the usage of computing power, memory,and/or bandwidth by consolidating data into single Web app that isaccessible via a network and making the data easily available tomultiple users. Further, this approach allows secure, customized accessto data by multiple users.

In an embodiment, an approach is presented for guided generation of Webapps based on organized data. The approach allows automatic analysis ofthe organized data to identify data types, and automatic suggestion ofwidgets corresponding to the data types. This results in a Web app thataccurately corresponds to the type of organized data that it is meant tostore. In addition, the Web app does not need to be specificallyprogrammed nor does it require a user to manually determine whichwidgets should be included in the Web app. Users do not need specializedknowledge of computer programming or of the data contained in theorganized data in order to generate a Web app. In some embodiments, useracceptance of suggested widgets may not be required; the Web app may beautomatically generated from the organized data according to thetechniques described above, and the suggested widgets are automaticallyincluded in the generated Web app.

Furthermore, the approach allows automatic identification and splittingof data types that may be split into a plurality of data types, andsuggesting widgets corresponding to the plurality of split data types.The approach provides a higher level of accuracy in the suggestedwidgets, by automatically splitting data types that are not split withinthe organized data. In addition, when data is imported into the new Webapp, the data is also able to be automatically split and associated withthe corresponding widgets. In contrast, with a ‘traditional’ spreadsheetor database, dividing a column into multiple columns requiresre-inputting the data that belongs to each new column. Newly added tableor spreadsheet columns are not automatically populated. Thus, with theapproaches described herein, the overall usability and functionality ofthe computing device and associated applications is also increased.

V. Implementation Examples

According to one embodiment, the techniques described herein areimplemented by at least one computing device. The techniques may beimplemented in whole or in part using a combination of at least oneserver computer and/or other computing devices that are coupled using anetwork, such as a packet data network. The computing devices may behard-wired to perform the techniques, or may include digital electronicdevices such as at least one application-specific integrated circuit(ASIC) or field programmable gate array (FPGA) that is persistentlyprogrammed to perform the techniques, or may include at least onegeneral purpose hardware processor programmed to perform the techniquespursuant to program instructions in firmware, memory, other storage, ora combination. Such computing devices may also combine custom hard-wiredlogic, ASICs, or FPGAs with custom programming to accomplish thedescribed techniques. The computing devices may be server computers,workstations, personal computers, portable computer systems, handhelddevices, mobile computing devices, wearable devices, body mounted orimplantable devices, smartphones, smart appliances, internetworkingdevices, autonomous or semi-autonomous devices such as robots orunmanned ground or aerial vehicles, any other electronic device thatincorporates hard-wired and/or program logic to implement the describedtechniques, one or more virtual computing machines or instances in adata center, and/or a network of server computers and/or personalcomputers.

FIG. 7 is a block diagram that illustrates an example computer systemwith which an embodiment may be implemented. In the example of FIG. 7, acomputer system 700 and instructions for implementing the disclosedtechnologies in hardware, software, or a combination of hardware andsoftware, are represented schematically, for example as boxes andcircles, at the same level of detail that is commonly used by persons ofordinary skill in the art to which this disclosure pertains forcommunicating about computer architecture and computer systemsimplementations.

Computer system 700 includes an input/output (I/O) subsystem 702 whichmay include a bus and/or other communication mechanism(s) forcommunicating information and/or instructions between the components ofthe computer system 700 over electronic signal paths. The I/O subsystem702 may include an I/O controller, a memory controller and at least oneI/O port. The electronic signal paths are represented schematically inthe drawings, for example as lines, unidirectional arrows, orbidirectional arrows.

At least one hardware processor 704 is coupled to I/O subsystem 702 forprocessing information and instructions. Hardware processor 704 mayinclude, for example, a general-purpose microprocessor ormicrocontroller and/or a special-purpose microprocessor such as anembedded system or a graphics processing unit (GPU) or a digital signalprocessor or ARM processor. Processor 704 may comprise an integratedarithmetic logic unit (ALU) or may be coupled to a separate ALU.

Computer system 700 includes one or more units of memory 706, such as amain memory, which is coupled to I/O subsystem 702 for electronicallydigitally storing data and instructions to be executed by processor 704.Memory 706 may include volatile memory such as various forms ofrandom-access memory (RAM) or other dynamic storage device. Memory 706also may be used for storing temporary variables or other intermediateinformation during execution of instructions to be executed by processor704. Such instructions, when stored in non-transitory computer-readablestorage media accessible to processor 704, can render computer system700 into a special-purpose machine that is customized to perform theoperations specified in the instructions.

Computer system 700 further includes non-volatile memory such as readonly memory (ROM) 708 or other static storage device coupled to I/Osubsystem 702 for storing information and instructions for processor704. The ROM 708 may include various forms of programmable ROM (PROM)such as erasable PROM (EPROM) or electrically erasable PROM (EEPROM). Aunit of persistent storage 710 may include various forms of non-volatileRAM (NVRAM), such as FLASH memory, or solid-state storage, magnetic diskor optical disk such as CD-ROM or DVD-ROM, and may be coupled to I/Osubsystem 702 for storing information and instructions. Storage 710 isan example of a non-transitory computer-readable medium that may be usedto store instructions and data which when executed by the processor 704cause performing computer-implemented methods to execute the techniquesherein.

The instructions in memory 706, ROM 708 or storage 710 may comprise oneor more sets of instructions that are organized as modules, methods,objects, functions, routines, or calls. The instructions may beorganized as one or more computer programs, operating system services,or application programs including mobile apps. The instructions maycomprise an operating system and/or system software; one or morelibraries to support multimedia, programming or other functions; dataprotocol instructions or stacks to implement TCP/IP, HTTP or othercommunication protocols; file format processing instructions to parse orrender files coded using HTML, XML, JPEG, MPEG or PNG; user interfaceinstructions to render or interpret commands for a graphical userinterface (GUI), command-line interface or text user interface;application software such as an office suite, internet accessapplications, design and manufacturing applications, graphicsapplications, audio applications, software engineering applications,educational applications, games or miscellaneous applications. Theinstructions may implement a Web server, Web application server or Webclient. The instructions may be organized as a presentation layer,application layer and data storage layer such as a relational databasesystem using structured query language (SQL) or no SQL, an object store,a graph database, a flat file system or other data storage.

Computer system 700 may be coupled via I/O subsystem 702 to at least oneoutput device 712. In one embodiment, output device 712 is a digitalcomputer display. Examples of a display that may be used in variousembodiments include a touch screen display or a light-emitting diode(LED) display or a liquid crystal display (LCD) or an e-paper display.Computer system 700 may include other type(s) of output devices 712,alternatively or in addition to a display device. Examples of otheroutput devices 712 include printers, ticket printers, plotters,projectors, sound cards or video cards, speakers, buzzers orpiezoelectric devices or other audible devices, lamps or LED or LCDindicators, haptic devices, actuators or servos.

At least one input device 714 is coupled to I/O subsystem 702 forcommunicating signals, data, command selections or gestures to processor704. Examples of input devices 714 include touch screens, microphones,still and video digital cameras, alphanumeric and other keys, keypads,keyboards, graphics tablets, image scanners, joysticks, clocks,switches, buttons, dials, slides, and/or various types of sensors suchas force sensors, motion sensors, heat sensors, accelerometers,gyroscopes, and inertial measurement unit (IMU) sensors and/or varioustypes of transceivers such as wireless, such as cellular or Wi-Fi, radiofrequency (RF) or infrared (IR) transceivers and Global PositioningSystem (GPS) transceivers.

Another type of input device is a control device 716, which may performcursor control or other automated control functions such as navigationin a graphical interface on a display screen, alternatively or inaddition to input functions. Control device 716 may be a touchpad, amouse, a trackball, or cursor direction keys for communicating directioninformation and command selections to processor 704 and for controllingcursor movement on display 712. The input device may have at least twodegrees of freedom in two axes, a first axis (e.g., x) and a second axis(e.g., y), that allows the device to specify positions in a plane.Another type of input device is a wired, wireless, or optical controldevice such as a joystick, wand, console, steering wheel, pedal,gearshift mechanism or other type of control device. An input device 714may include a combination of multiple different input devices, such as avideo camera and a depth sensor.

In another embodiment, computer system 700 may comprise an internet ofthings (IoT) device in which one or more of the output device 712, inputdevice 714, and control device 716 are omitted. Or, in such anembodiment, the input device 714 may comprise one or more cameras,motion detectors, thermometers, microphones, seismic detectors, othersensors or detectors, measurement devices or encoders and the outputdevice 712 may comprise a special-purpose display such as a single-lineLED or LCD display, one or more indicators, a display panel, a meter, avalve, a solenoid, an actuator or a servo.

When computer system 700 is a mobile computing device, input device 714may comprise a global positioning system (GPS) receiver coupled to a GPSmodule that is capable of triangulating to a plurality of GPSsatellites, determining and generating geo-location or position datasuch as latitude-longitude values for a geophysical location of thecomputer system 700. Output device 712 may include hardware, software,firmware and interfaces for generating position reporting packets,notifications, pulse or heartbeat signals, or other recurring datatransmissions that specify a position of the computer system 700, aloneor in combination with other application-specific data, directed towardhost 724 or server 730.

Computer system 700 may implement the techniques described herein usingcustomized hard-wired logic, at least one ASIC or FPGA, firmware and/orprogram instructions or logic which when loaded and used or executed incombination with the computer system causes or programs the computersystem to operate as a special-purpose machine. According to oneembodiment, the techniques herein are performed by computer system 700in response to processor 704 executing at least one sequence of at leastone instruction contained in main memory 706. Such instructions may beread into main memory 706 from another storage medium, such as storage710. Execution of the sequences of instructions contained in main memory706 causes processor 704 to perform the process steps described herein.In alternative embodiments, hard-wired circuitry may be used in place ofor in combination with software instructions.

The term “storage media” as used herein refers to any non-transitorymedia that store data and/or instructions that cause a machine tooperation in a specific fashion. Such storage media may comprisenon-volatile media and/or volatile media. Non-volatile media includes,for example, optical or magnetic disks, such as storage 710. Volatilemedia includes dynamic memory, such as memory 706. Common forms ofstorage media include, for example, a hard disk, solid state drive,flash drive, magnetic data storage medium, any optical or physical datastorage medium, memory chip, or the like.

Storage media is distinct from but may be used in conjunction withtransmission media. Transmission media participates in transferringinformation between storage media. For example, transmission mediaincludes coaxial cables, copper wire and fiber optics, including thewires that comprise a bus of I/O subsystem 702. Transmission media canalso take the form of acoustic or light waves, such as those generatedduring radio-wave and infra-red data communications.

Various forms of media may be involved in carrying at least one sequenceof at least one instruction to processor 704 for execution. For example,the instructions may initially be carried on a magnetic disk orsolid-state drive of a remote computer. The remote computer can load theinstructions into its dynamic memory and send the instructions over acommunication link such as a fiber optic or coaxial cable or telephoneline using a modem. A modem or router local to computer system 700 canreceive the data on the communication link and convert the data to aformat that can be read by computer system 700. For instance, a receiversuch as a radio frequency antenna or an infrared detector can receivethe data carried in a wireless or optical signal and appropriatecircuitry can provide the data to I/O subsystem 702 such as place thedata on a bus. I/O subsystem 702 carries the data to memory 706, fromwhich processor 704 retrieves and executes the instructions. Theinstructions received by memory 706 may optionally be stored on storage710 either before or after execution by processor 704.

Computer system 700 also includes a communication interface 718 coupledto bus 702. Communication interface 718 provides a two-way datacommunication coupling to network link(s) 720 that are directly orindirectly connected to at least one communication networks, such as anetwork 722 or a public or private cloud on the Internet. For example,communication interface 718 may be an Ethernet networking interface,integrated-services digital network (ISDN) card, cable modem, satellitemodem, or a modem to provide a data communication connection to acorresponding type of communications line, for example an Ethernet cableor a metal cable of any kind or a fiber-optic line or a telephone line.Network 722 broadly represents a local area network (LAN), wide-areanetwork (WAN), campus network, internetwork or any combination thereof.Communication interface 718 may comprise a LAN card to provide a datacommunication connection to a compatible LAN, or a cellularradiotelephone interface that is wired to send or receive cellular dataaccording to cellular radiotelephone wireless networking standards, or asatellite radio interface that is wired to send or receive digital dataaccording to satellite wireless networking standards. In any suchimplementation, communication interface 718 sends and receiveselectrical, electromagnetic or optical signals over signal paths thatcarry digital data streams representing various types of information.

Network link 720 typically provides electrical, electromagnetic, oroptical data communication directly or through at least one network toother data devices, using, for example, satellite, cellular, Wi-Fi, orBLUETOOTH technology. For example, network link 720 may provide aconnection through a network 722 to a host computer 724.

Furthermore, network link 720 may provide a connection through network722 or to other computing devices via internetworking devices and/orcomputers that are operated by an Internet Service Provider (ISP) 726.ISP 726 provides data communication services through a world-wide packetdata communication network represented as internet 728. A servercomputer 730 may be coupled to internet 728. Server 730 broadlyrepresents any computer, data center, virtual machine or virtualcomputing instance with or without a hypervisor, or computer executing acontainerized program system such as DOCKER or KUBERNETES. Server 730may represent an electronic digital service that is implemented usingmore than one computer or instance and that is accessed and used bytransmitting Web services requests, uniform resource locator (URL)strings with parameters in HTTP payloads, API calls, app services calls,or other service calls. Computer system 700 and server 730 may formelements of a distributed computing system that includes othercomputers, a processing cluster, server farm or other organization ofcomputers that cooperate to perform tasks or execute applications orservices. Server 730 may comprise one or more sets of instructions thatare organized as modules, methods, objects, functions, routines, orcalls. The instructions may be organized as one or more computerprograms, operating system services, or application programs includingmobile apps. The instructions may comprise an operating system and/orsystem software; one or more libraries to support multimedia,programming or other functions; data protocol instructions or stacks toimplement TCP/IP, HTTP or other communication protocols; file formatprocessing instructions to parse or render files coded using HTML, XML,JPEG, MPEG or PNG; user interface instructions to render or interpretcommands for a graphical user interface (GUI), command-line interface ortext user interface; application software such as an office suite,internet access applications, design and manufacturing applications,graphics applications, audio applications, software engineeringapplications, educational applications, games or miscellaneousapplications. Server 730 may comprise a Web application server thathosts a presentation layer, application layer and data storage layersuch as a relational database system using structured query language(SQL) or no SQL, an object store, a graph database, a flat file systemor other data storage.

Computer system 700 can send messages and receive data and instructions,including program code, through the network(s), network link 720 andcommunication interface 718. In the Internet example, a server 730 mighttransmit a requested code for an application program through Internet728, ISP 726, local network 722 and communication interface 718. Thereceived code may be executed by processor 704 as it is received, and/orstored in storage 710, or other non-volatile storage for laterexecution.

The execution of instructions as described in this section may implementa process in the form of an instance of a computer program that is beingexecuted, and consisting of program code and its current activity.Depending on the operating system (OS), a process may be made up ofmultiple threads of execution that execute instructions concurrently. Inthis context, a computer program is a passive collection ofinstructions, while a process may be the actual execution of thoseinstructions. Several processes may be associated with the same program;for example, opening up several instances of the same program oftenmeans more than one process is being executed. Multitasking may beimplemented to allow multiple processes to share processor 704. Whileeach processor 704 or core of the processor executes a single task at atime, computer system 700 may be programmed to implement multitasking toallow each processor to switch between tasks that are being executedwithout having to wait for each task to finish. In an embodiment,switches may be performed when tasks perform input/output operations,when a task indicates that it can be switched, or on hardwareinterrupts. Time-sharing may be implemented to allow fast response forinteractive user applications by rapidly performing context switches toprovide the appearance of concurrent execution of multiple processessimultaneously. In an embodiment, for security and reliability, anoperating system may prevent direct communication between independentprocesses, providing strictly mediated and controlled inter-processcommunication functionality.

1. A system for generating a Web application, the system comprising: oneor more processors; a non-transitory computer-readable medium storinginstructions which, when executed by the one or more processors, cause:receiving organized data; after receiving the organized data:determining a plurality of data types contained in the organized data;for each data type of the plurality of data types, determining one ormore suggested widgets for receiving input data of the data type;wherein determining the one or more suggested widgets for each data typecomprises: determining a particular data type can be split into two ormore data types; determining a suggested widget for each data type fromthe two or more data types for the particular data type; displaying theplurality of data types and the determined one or more suggested widgetsfor each data type of the plurality of data types, including thesuggested widget for each data type from the two or more data types forthe particular data type; in response to receiving user input acceptingthe one or more suggested widgets, generating a Web application formanaging the organized data, wherein the Web application comprises theone or more suggested widgets.
 2. The system of claim 1, wherein eachwidget of the one or more suggested widgets is a particular widget type,wherein determining the one or more suggested widgets for each data typecomprises selecting one or more particular widget types corresponding tothe data type.
 3. The system of claim 1 wherein displaying the pluralityof data types includes displaying the two or more data types for theparticular data type.
 4. The system of claim 1 further comprisinginstructions which, when executed by the one or more processors, cause:determining two or more data types of the plurality of data types can besplit; displaying the two or more data types as selectable options; inresponse to receiving user input selecting the particular data type fromthe two or more data types of the plurality of data types, splitting theparticular data type into two or more data types.
 5. The system of claim1 further comprising instructions which, when executed by the one ormore processors, cause: in response to determining the particular datatype can be split into two or more data types, displaying two or moresuggested data types; in response to receiving user input accepting thetwo or more suggested data types, splitting the particular data typeinto the two or more suggested data types.
 6. The system of claim 1further comprising instructions which, when executed by the one or moreprocessors, cause, after displaying the one or more suggested widgets:receiving user input to split a particular suggested widget; determiningtwo or more suggested widgets for the particular suggested widget;replacing the particular suggested widget with the two or more suggestedwidgets for the particular suggested widget wherein the Web applicationcomprises the two or more suggested widgets but does not comprise theparticular suggested widget.
 7. The system of claim 1 further comprisinginstructions which, when executed by the one or more processors, cause,after displaying the one or more suggested widgets: receiving user inputto merge two or more particular suggested widgets; determining areplacement suggested widget for the two or more particular suggestedwidgets; replacing the two or more particular suggested widgets with thereplacement suggested widget wherein the Web application comprises thereplacement suggested widget but does not comprise the two or moreparticular suggested widgets.
 8. The system of claim 1 furthercomprising instructions which, when executed by the one or moreprocessors, cause: storing the organized data using the Web application;wherein storing the organized data comprises dividing the organized datainto a plurality of portions, wherein each portion of the plurality ofportions is associated with a suggested widget of the one or moresuggested widgets.
 9. The system of claim 1 wherein determining theparticular data type can be split into two or more data types comprisesdetermining the portion of organized data associated with the particulardata type corresponds to two or more different data types.
 10. Thesystem of claim 1 wherein determining the particular data type can besplit into two or more data types comprises determining the portion oforganized data associated with the particular data type includes one ormore delimiters.
 11. A method for generating a Web application, themethod comprising: receiving organized data; after receiving theorganized data: determining a plurality of data types contained in theorganized data; for each data type of the plurality of data types,determining one or more suggested widgets for receiving input data ofthe data type; wherein determining the one or more suggested widgets foreach data type comprises: determining a particular data type can besplit into two or more data types; determining a suggested widget foreach data type from the two or more data types for the particular datatype; displaying the plurality of data types and the determined one ormore suggested widgets for each data type of the plurality of datatypes, including the suggested widget for each data type from the two ormore data types for the particular data type; in response to receivinguser input accepting the one or more suggested widgets, generating a Webapplication for managing the organized data, wherein the Web applicationcomprises the one or more suggested widgets.
 12. The method of claim 11,wherein each widget of the one or more suggested widgets is a particularwidget type, wherein determining the one or more suggested widgets foreach data type comprises selecting one or more particular widget typescorresponding to the data type.
 13. The method of claim 11 whereindisplaying the plurality of data types includes displaying the two ormore data types for the particular data type.
 14. The method of claim 11further comprising: determining two or more data types of the pluralityof data types can be split; displaying the two or more data types asselectable options; in response to receiving user input selecting theparticular data type from the two or more data types of the plurality ofdata types, splitting the particular data type into two or more datatypes.
 15. The method of claim 11 further comprising: in response todetermining the particular data type can be split into two or more datatypes, displaying two or more suggested data types; in response toreceiving user input accepting the two or more suggested data types,splitting the particular data type into the two or more suggested datatypes.
 16. The method of claim 11 further comprising, after displayingthe one or more suggested widgets: receiving user input to split aparticular suggested widget; determining two or more suggested widgetsfor the particular suggested widget; replacing the particular suggestedwidget with the two or more suggested widgets for the particularsuggested widget wherein the Web application comprises the two or moresuggested widgets but does not comprise the particular suggested widget.17. The method of claim 11 further comprising, after displaying the oneor more suggested widgets: receiving user input to merge two or moreparticular suggested widgets; determining a replacement suggested widgetfor the two or more particular suggested widgets; replacing the two ormore particular suggested widgets with the replacement suggested widgetwherein the Web application comprises the replacement suggested widgetbut does not comprise the two or more particular suggested widgets. 18.The method of claim 11 further comprising: storing the organized datausing the Web application; wherein storing the organized data comprisesdividing the organized data into a plurality of portions, wherein eachportion of the plurality of portions is associated with a suggestedwidget of the one or more suggested widgets.
 19. The method of claim 11wherein determining the particular data type can be split into two ormore data types comprises determining the portion of organized dataassociated with the particular data type corresponds to two or moredifferent data types.
 20. The method of claim 11 wherein determining theparticular data type can be split into two or more data types comprisesdetermining the portion of organized data associated with the particulardata type includes one or more delimiters.